Cube Yogi
Cube Yogi
Leader in Zoho Solutions/Consultation

Fill Delivery date Automatically

Question

You can find this question from this link 👉Find next upcomming date in report (calendar or list) with workflow

Answer

You can find the solution to the question from the video below

The Parameters for the Workflow are given below

The Code Snippet is as follows

expiry_date = input.Products.Days_to_Expire.toLong();
avail_dates = Delivery_Dates[Status == "Free" && Delivery_Date in next expiry_date days] sort by Delivery_Date asc;
select_date = avail_dates.Delivery_Date;
input.Expected_Delivery_Date = select_date;